sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_new_users_day_number \
--export-dir /user/spark/warehouse/vivo_app_warehouse/ads_new_users_day_number \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'dt' \
--input-null-string '\\N' \
--input-null-non-string '\\N'

sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_daily_active_users_number \
--export-dir /user/spark/warehouse/vivo_app_warehouse/ads_daily_active_users_number \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'dt' \
--input-null-string '\\N' \
--input-null-non-string '\\N'


sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_weekly_active_users_number \
--export-dir /user/spark/warehouse/vivo_app_warehouse/ads_weekly_active_users_number \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'week_start_date' \
--input-null-string '\\N' \
--input-null-non-string '\\N'



sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_month_active_users_number \
--export-dir /user/spark/warehouse/vivo_app_warehouse/ads_month_active_users_number \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'month' \
--input-null-string '\\N' \
--input-null-non-string '\\N'

sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_user_retention_rate \
--export-dir /user/spark/warehouse/vivo_app_warehouse/ads_user_retention_rate \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'register_date,new_users,dayl_retained' \
--input-null-string '\\N' \
--input-null-non-string '\\N'



sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_user_use_time_day \
--export-dir /user/spark/warehouse/vivo_app_warehouse/ads_user_use_time_day \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'dt' \
--input-null-string '\\N' \
--input-null-non-string '\\N'

sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_user_active_time_day \
--export-dir /user/spark/warehouse/vivo_app_warehouse/ads_user_active_time_day \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'hour_of_day,active_users' \
--input-null-string '\\N' \
--input-null-non-string '\\N'

sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_function_use_par \
--export-dir /user/spark/warehouse/vivo_app_warehouse/ads_function_use_par \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'dt,event_type' \
--input-null-string '\\N' \
--input-null-non-string '\\N'


sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_funnel_tb \
--export-dir /user/spark/warehouse/vivo_app_warehouse/ads_funnel_tb \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'total_users,product_viewers,cart_adders,checkout_starters,paying_users' \
--input-null-string '\\N' \
--input-null-non-string '\\N'


sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_app_download_uninstall \
--export-dir /user/spark/warehouse/vivo_app_warehouse/ads_app_download_uninstall \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'app_id,app_name,app_category' \
--input-null-string '\\N' \
--input-null-non-string '\\N'


sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table ads_app_crash_persponse \
--export-dir /user/spark/warehouse/vivo_app_warehouse/ads_app_crash_persponse \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'app_id,app_name,app_version' \
--input-null-string '\\N' \
--input-null-non-string '\\N'


sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table zb4_1 \
--export-dir /user/spark/warehouse/vivo_app_warehouse/zb4_1 \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'device_type,device_count' \
--input-null-string '\\N' \
--input-null-non-string '\\N'


sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table zb4_2 \
--export-dir /user/spark/warehouse/vivo_app_warehouse/zb4_2 \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'emory_usage' \
--input-null-string '\\N' \
--input-null-non-string '\\N'


sqoop export \
--connect "jdbc:mysql://node101:3306/vivo_ads_warehouse?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table zb5 \
--export-dir /user/spark/warehouse/vivo_app_warehouse/zb5 \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--update-key 'dt,active_users,paying_count' \
--input-null-string '\\N' \
--input-null-non-string '\\N'